IF exists(SELECT * FROM dbo.sysobjects WHERE name='WEB_klasinfo' AND xtype='P') 
BEGIN
	DROP PROCEDURE WEB_klasinfo
END
GO

create procedure WEB_klasinfo
as
set nocount on

select 1,'<?xml version="1.0"  encoding="ISO-8859-1" ?><lokalenInfo>' as tekst
union 
select 2,'<lokalen naam="' + rtrim(lokalen) +'">'+'</lokalen>' from lokalenvolgorde
union
select 3,'</lokalenInfo>'